package net.wantongtech.xa.uploadbasicinfo.dao;

import com.wtkj.dao.impl.BaseDataTemplate;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * 处理错误的门架2类交易服务实现
 *
 * @author MaShibo
 * 日期 :  2020/2/1
 */
@Repository
public class DealWithErrorRecordTransDao extends BaseDataTemplate {

    public List<Long> queryDealingRecordTransMsgId() {
        final String sql =
                "SELECT A.CONMSGID\n" +
                        "  FROM TQ_INTERACTIONORGMSGRECEIVE A\n" +
                        " WHERE A.BIZCODE = 61011002\n" +
                        "   AND A.TOLLPROVINCEID = '610201'\n" +
                        "   AND A.STATE = 1";
        return jdbcTemplate.queryForList(sql, Long.class);
    }

}
